{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "from data import Data\n",
    "\n",
    "data = Data()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>product_id</th>\n",
       "      <th>product_num</th>\n",
       "      <th>route_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>P202201101</td>\n",
       "      <td>8</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>P202201102</td>\n",
       "      <td>4</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>P202201103</td>\n",
       "      <td>4</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>P202201104</td>\n",
       "      <td>2</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>P202201105</td>\n",
       "      <td>8</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>P202201106</td>\n",
       "      <td>8</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>P202201107</td>\n",
       "      <td>4</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>P202201108</td>\n",
       "      <td>4</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>P202201109</td>\n",
       "      <td>2</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>P202201110</td>\n",
       "      <td>4</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>P202201111</td>\n",
       "      <td>4</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>P202201112</td>\n",
       "      <td>2</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>P202201113</td>\n",
       "      <td>8</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>P202201114</td>\n",
       "      <td>4</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>P202201115</td>\n",
       "      <td>8</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>P202201116</td>\n",
       "      <td>4</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>P202201117</td>\n",
       "      <td>4</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>P202201118</td>\n",
       "      <td>4</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>P202201119</td>\n",
       "      <td>4</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>P202201120</td>\n",
       "      <td>2</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>P202201121</td>\n",
       "      <td>2</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>P202201122</td>\n",
       "      <td>4</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>P202201123</td>\n",
       "      <td>2</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>P202201124</td>\n",
       "      <td>2</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>P202201125</td>\n",
       "      <td>4</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>P202201126</td>\n",
       "      <td>8</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>P202201127</td>\n",
       "      <td>2</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>P202201128</td>\n",
       "      <td>4</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>P202201129</td>\n",
       "      <td>8</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>P202201130</td>\n",
       "      <td>2</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>P202201131</td>\n",
       "      <td>4</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>P202201132</td>\n",
       "      <td>4</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>P202201133</td>\n",
       "      <td>2</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>P202201134</td>\n",
       "      <td>8</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>P202201135</td>\n",
       "      <td>4</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>P202201136</td>\n",
       "      <td>4</td>\n",
       "      <td>D1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>P202201137</td>\n",
       "      <td>4</td>\n",
       "      <td>B1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>P202201138</td>\n",
       "      <td>4</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>P202201139</td>\n",
       "      <td>2</td>\n",
       "      <td>A1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>P202201140</td>\n",
       "      <td>8</td>\n",
       "      <td>C1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    product_id  product_num route_id\n",
       "0   P202201101            8       A1\n",
       "1   P202201102            4       B1\n",
       "2   P202201103            4       B1\n",
       "3   P202201104            2       C1\n",
       "4   P202201105            8       B1\n",
       "5   P202201106            8       C1\n",
       "6   P202201107            4       D1\n",
       "7   P202201108            4       A1\n",
       "8   P202201109            2       B1\n",
       "9   P202201110            4       B1\n",
       "10  P202201111            4       A1\n",
       "11  P202201112            2       C1\n",
       "12  P202201113            8       D1\n",
       "13  P202201114            4       A1\n",
       "14  P202201115            8       C1\n",
       "15  P202201116            4       B1\n",
       "16  P202201117            4       C1\n",
       "17  P202201118            4       D1\n",
       "18  P202201119            4       B1\n",
       "19  P202201120            2       D1\n",
       "20  P202201121            2       A1\n",
       "21  P202201122            4       D1\n",
       "22  P202201123            2       C1\n",
       "23  P202201124            2       D1\n",
       "24  P202201125            4       B1\n",
       "25  P202201126            8       A1\n",
       "26  P202201127            2       C1\n",
       "27  P202201128            4       D1\n",
       "28  P202201129            8       A1\n",
       "29  P202201130            2       C1\n",
       "30  P202201131            4       B1\n",
       "31  P202201132            4       D1\n",
       "32  P202201133            2       D1\n",
       "33  P202201134            8       A1\n",
       "34  P202201135            4       C1\n",
       "35  P202201136            4       D1\n",
       "36  P202201137            4       B1\n",
       "37  P202201138            4       A1\n",
       "38  P202201139            2       A1\n",
       "39  P202201140            8       C1"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(data.product_info)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>route_id</th>\n",
       "      <th>route_No</th>\n",
       "      <th>name</th>\n",
       "      <th>equ_type</th>\n",
       "      <th>time</th>\n",
       "      <th>unit</th>\n",
       "      <th>ready_time</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>A1</td>\n",
       "      <td>1</td>\n",
       "      <td>工序A</td>\n",
       "      <td>T-01</td>\n",
       "      <td>4h</td>\n",
       "      <td>批</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>A1</td>\n",
       "      <td>2</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>480-660min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>A1</td>\n",
       "      <td>3</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>A1</td>\n",
       "      <td>4</td>\n",
       "      <td>工序D</td>\n",
       "      <td>T-05</td>\n",
       "      <td>8h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>A1</td>\n",
       "      <td>5</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>300-500min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>A1</td>\n",
       "      <td>6</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>A1</td>\n",
       "      <td>7</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-04</td>\n",
       "      <td>350-520min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>A1</td>\n",
       "      <td>8</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>A1</td>\n",
       "      <td>9</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>400-550min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>A1</td>\n",
       "      <td>10</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>A1</td>\n",
       "      <td>11</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>380-560min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>A1</td>\n",
       "      <td>12</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>A1</td>\n",
       "      <td>13</td>\n",
       "      <td>工序D</td>\n",
       "      <td>T-05</td>\n",
       "      <td>8h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>B1</td>\n",
       "      <td>1</td>\n",
       "      <td>工序A</td>\n",
       "      <td>T-01</td>\n",
       "      <td>4h</td>\n",
       "      <td>批</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>B1</td>\n",
       "      <td>2</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>200-300min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>B1</td>\n",
       "      <td>3</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>B1</td>\n",
       "      <td>4</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-04</td>\n",
       "      <td>400-600min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>B1</td>\n",
       "      <td>5</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>B1</td>\n",
       "      <td>6</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>300-500min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B1</td>\n",
       "      <td>7</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>B1</td>\n",
       "      <td>8</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>240-350min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>B1</td>\n",
       "      <td>9</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>B1</td>\n",
       "      <td>10</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-04</td>\n",
       "      <td>220-400min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>B1</td>\n",
       "      <td>11</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>B1</td>\n",
       "      <td>12</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>420-630min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>B1</td>\n",
       "      <td>13</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>B1</td>\n",
       "      <td>14</td>\n",
       "      <td>工序D</td>\n",
       "      <td>T-05</td>\n",
       "      <td>8h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>C1</td>\n",
       "      <td>1</td>\n",
       "      <td>工序A</td>\n",
       "      <td>T-01</td>\n",
       "      <td>4h</td>\n",
       "      <td>批</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>C1</td>\n",
       "      <td>2</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>180-300min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>C1</td>\n",
       "      <td>3</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>C1</td>\n",
       "      <td>4</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-04</td>\n",
       "      <td>360-550min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>C1</td>\n",
       "      <td>5</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>C1</td>\n",
       "      <td>6</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>300-500min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>C1</td>\n",
       "      <td>7</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>C1</td>\n",
       "      <td>8</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>240-350min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>C1</td>\n",
       "      <td>9</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>C1</td>\n",
       "      <td>10</td>\n",
       "      <td>工序D</td>\n",
       "      <td>T-05</td>\n",
       "      <td>8h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>C1</td>\n",
       "      <td>11</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-04</td>\n",
       "      <td>200-400min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>C1</td>\n",
       "      <td>12</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>C1</td>\n",
       "      <td>13</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>400-600min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>C1</td>\n",
       "      <td>14</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>C1</td>\n",
       "      <td>15</td>\n",
       "      <td>工序D</td>\n",
       "      <td>T-05</td>\n",
       "      <td>8h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>D1</td>\n",
       "      <td>1</td>\n",
       "      <td>工序A</td>\n",
       "      <td>T-01</td>\n",
       "      <td>4h</td>\n",
       "      <td>批</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>D1</td>\n",
       "      <td>2</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>300-500min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>D1</td>\n",
       "      <td>3</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>D1</td>\n",
       "      <td>4</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-04</td>\n",
       "      <td>200-300min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>D1</td>\n",
       "      <td>5</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>D1</td>\n",
       "      <td>6</td>\n",
       "      <td>工序D</td>\n",
       "      <td>T-05</td>\n",
       "      <td>8h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>D1</td>\n",
       "      <td>7</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>400-550min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>D1</td>\n",
       "      <td>8</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>D1</td>\n",
       "      <td>9</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>300-450min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>D1</td>\n",
       "      <td>10</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>D1</td>\n",
       "      <td>11</td>\n",
       "      <td>工序D</td>\n",
       "      <td>T-05</td>\n",
       "      <td>8h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>D1</td>\n",
       "      <td>12</td>\n",
       "      <td>工序B</td>\n",
       "      <td>T-03</td>\n",
       "      <td>450-650min</td>\n",
       "      <td>批</td>\n",
       "      <td>0.5h</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>D1</td>\n",
       "      <td>13</td>\n",
       "      <td>工序C</td>\n",
       "      <td>T-02</td>\n",
       "      <td>0.2h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>D1</td>\n",
       "      <td>14</td>\n",
       "      <td>工序D</td>\n",
       "      <td>T-05</td>\n",
       "      <td>8h</td>\n",
       "      <td>节</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   route_id  route_No name equ_type        time unit ready_time\n",
       "0        A1         1  工序A     T-01          4h    批        NaN\n",
       "1        A1         2  工序B     T-03  480-660min    批       0.5h\n",
       "2        A1         3  工序C     T-02        0.2h    节        NaN\n",
       "3        A1         4  工序D     T-05          8h    节        NaN\n",
       "4        A1         5  工序B     T-03  300-500min    批       0.5h\n",
       "5        A1         6  工序C     T-02        0.2h    节        NaN\n",
       "6        A1         7  工序B     T-04  350-520min    批       0.5h\n",
       "7        A1         8  工序C     T-02        0.2h    节        NaN\n",
       "8        A1         9  工序B     T-03  400-550min    批       0.5h\n",
       "9        A1        10  工序C     T-02        0.2h    节        NaN\n",
       "10       A1        11  工序B     T-03  380-560min    批       0.5h\n",
       "11       A1        12  工序C     T-02        0.2h    节        NaN\n",
       "12       A1        13  工序D     T-05          8h    节        NaN\n",
       "13       B1         1  工序A     T-01          4h    批        NaN\n",
       "14       B1         2  工序B     T-03  200-300min    批       0.5h\n",
       "15       B1         3  工序C     T-02        0.2h    节        NaN\n",
       "16       B1         4  工序B     T-04  400-600min    批       0.5h\n",
       "17       B1         5  工序C     T-02        0.2h    节        NaN\n",
       "18       B1         6  工序B     T-03  300-500min    批       0.5h\n",
       "19       B1         7  工序C     T-02        0.2h    节        NaN\n",
       "20       B1         8  工序B     T-03  240-350min    批       0.5h\n",
       "21       B1         9  工序C     T-02        0.2h    节        NaN\n",
       "22       B1        10  工序B     T-04  220-400min    批       0.5h\n",
       "23       B1        11  工序C     T-02        0.2h    节        NaN\n",
       "24       B1        12  工序B     T-03  420-630min    批       0.5h\n",
       "25       B1        13  工序C     T-02        0.2h    节        NaN\n",
       "26       B1        14  工序D     T-05          8h    节        NaN\n",
       "27       C1         1  工序A     T-01          4h    批        NaN\n",
       "28       C1         2  工序B     T-03  180-300min    批       0.5h\n",
       "29       C1         3  工序C     T-02        0.2h    节        NaN\n",
       "30       C1         4  工序B     T-04  360-550min    批       0.5h\n",
       "31       C1         5  工序C     T-02        0.2h    节        NaN\n",
       "32       C1         6  工序B     T-03  300-500min    批       0.5h\n",
       "33       C1         7  工序C     T-02        0.2h    节        NaN\n",
       "34       C1         8  工序B     T-03  240-350min    批       0.5h\n",
       "35       C1         9  工序C     T-02        0.2h    节        NaN\n",
       "36       C1        10  工序D     T-05          8h    节        NaN\n",
       "37       C1        11  工序B     T-04  200-400min    批       0.5h\n",
       "38       C1        12  工序C     T-02        0.2h    节        NaN\n",
       "39       C1        13  工序B     T-03  400-600min    批       0.5h\n",
       "40       C1        14  工序C     T-02        0.2h    节        NaN\n",
       "41       C1        15  工序D     T-05          8h    节        NaN\n",
       "42       D1         1  工序A     T-01          4h    批        NaN\n",
       "43       D1         2  工序B     T-03  300-500min    批       0.5h\n",
       "44       D1         3  工序C     T-02        0.2h    节        NaN\n",
       "45       D1         4  工序B     T-04  200-300min    批       0.5h\n",
       "46       D1         5  工序C     T-02        0.2h    节        NaN\n",
       "47       D1         6  工序D     T-05          8h    节        NaN\n",
       "48       D1         7  工序B     T-03  400-550min    批       0.5h\n",
       "49       D1         8  工序C     T-02        0.2h    节        NaN\n",
       "50       D1         9  工序B     T-03  300-450min    批       0.5h\n",
       "51       D1        10  工序C     T-02        0.2h    节        NaN\n",
       "52       D1        11  工序D     T-05          8h    节        NaN\n",
       "53       D1        12  工序B     T-03  450-650min    批       0.5h\n",
       "54       D1        13  工序C     T-02        0.2h    节        NaN\n",
       "55       D1        14  工序D     T-05          8h    节        NaN"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(data.route_info)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>equ_name</th>\n",
       "      <th>equ_type</th>\n",
       "      <th>unit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Z-1001</td>\n",
       "      <td>T-01</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Z-1002</td>\n",
       "      <td>T-01</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Y-2045</td>\n",
       "      <td>T-02</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>JM-3001</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JM-3002</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>JM-3003</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>JM-3004</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>JM-3005</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>JM-3006</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>JM-3007</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>JM-3008</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>JM-3009</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>JM-3010</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>JM-3011</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>JM-3012</td>\n",
       "      <td>T-03</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>JH-3001</td>\n",
       "      <td>T-04</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>JH-3002</td>\n",
       "      <td>T-04</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>JH-3003</td>\n",
       "      <td>T-04</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>JH-3004</td>\n",
       "      <td>T-04</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>JH-3005</td>\n",
       "      <td>T-04</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>JH-3006</td>\n",
       "      <td>T-04</td>\n",
       "      <td>批</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>DI-4001</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>DI-4002</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>DI-4003</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>DI-4004</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>DI-4005</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>DI-4006</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>DI-4007</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>DI-4008</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>DI-4009</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>DI-4010</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>DI-4011</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>DI-4012</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>DI-4013</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>DI-4014</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>DI-4015</td>\n",
       "      <td>T-05</td>\n",
       "      <td>节</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   equ_name equ_type unit\n",
       "0    Z-1001     T-01    批\n",
       "1    Z-1002     T-01    批\n",
       "2    Y-2045     T-02    节\n",
       "3   JM-3001     T-03    批\n",
       "4   JM-3002     T-03    批\n",
       "5   JM-3003     T-03    批\n",
       "6   JM-3004     T-03    批\n",
       "7   JM-3005     T-03    批\n",
       "8   JM-3006     T-03    批\n",
       "9   JM-3007     T-03    批\n",
       "10  JM-3008     T-03    批\n",
       "11  JM-3009     T-03    批\n",
       "12  JM-3010     T-03    批\n",
       "13  JM-3011     T-03    批\n",
       "14  JM-3012     T-03    批\n",
       "15  JH-3001     T-04    批\n",
       "16  JH-3002     T-04    批\n",
       "17  JH-3003     T-04    批\n",
       "18  JH-3004     T-04    批\n",
       "19  JH-3005     T-04    批\n",
       "20  JH-3006     T-04    批\n",
       "21  DI-4001     T-05    节\n",
       "22  DI-4002     T-05    节\n",
       "23  DI-4003     T-05    节\n",
       "24  DI-4004     T-05    节\n",
       "25  DI-4005     T-05    节\n",
       "26  DI-4006     T-05    节\n",
       "27  DI-4007     T-05    节\n",
       "28  DI-4008     T-05    节\n",
       "29  DI-4009     T-05    节\n",
       "30  DI-4010     T-05    节\n",
       "31  DI-4011     T-05    节\n",
       "32  DI-4012     T-05    节\n",
       "33  DI-4013     T-05    节\n",
       "34  DI-4014     T-05    节\n",
       "35  DI-4015     T-05    节"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(data.quipment_info)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.8.10 64-bit",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.10"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "78f5b707d86fd9281530b9fa2dbdbe1b33232c3b651a8e052360c651d4996094"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
